set DB_BASE_DIR=E:\source\dbsourcetools\DBSourceTools_root\TestFiles\control\AdventureWorks\AdventureWorksLT\
set BASE_BIN_DIR=E:\source\dbsourcetools\DBSourceTools_root\DBSourceTools\DBSourceTools\bin\Debug\
set PROJECT_BASE_DIR=E:\source\dbsourcetools\DBSourceTools_root\TestFiles\control\AdventureWorks\
set PATCH_DIR=E:\source\dbsourcetools\DBSourceTools_root\TestFiles\control\AdventureWorks\AdventureWorksLT\DeploymentTargets\Adventure-Works\
rem
sqlcmd  -S (local) -E  -i %DB_BASE_DIR%DeploymentTargets\Adventure-Works\Adventure-Works_DropDB.sql
sqlcmd  -S (local) -E  -i %DB_BASE_DIR%DeploymentTargets\Adventure-Works\Adventure-Works_CreateDB.sql
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Schemas\SalesLT.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%XmlSchemas\SalesLT.ProductDescriptionSchemaCollection.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\AccountNumber.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\Flag.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\Name.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\NameStyle.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\OrderNumber.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%DataTypes\Phone.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.ProductCategory.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.ProductCategory" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Functions\dbo.ufnGetAllCategories.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.Customer.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.Customer" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Functions\dbo.ufnGetCustomerInformation.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Functions\dbo.ufnGetSalesOrderStatusText.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\ErrorLog.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "ErrorLog" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\BuildVersion.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "BuildVersion" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.Address.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.Address" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.CustomerAddress.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.CustomerAddress" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.ProductModel.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.ProductModel" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.Product.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.Product" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.ProductDescription.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.ProductDescription" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.ProductModelProductDescription.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.ProductModelProductDescription" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.SalesOrderHeader.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.SalesOrderHeader" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Tables\SalesLT.SalesOrderDetail.sql"
"%BASE_BIN_DIR%DBSourceDataLoader.exe" %PROJECT_BASE_DIR% AdventureWorksLT Adventure-Works "SalesLT.SalesOrderDetail" "%PROJECT_BASE_DIR%\AdventureWorks.xml"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Views\SalesLT.vGetAllCategories.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Views\SalesLT.vProductAndDescription.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Views\SalesLT.vProductModelCatalogDescription.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Procs\uspPrintError.sql"
sqlcmd  -S (local) -d Adventure-Works -E  -i "%DB_BASE_DIR%Procs\uspLogError.sql"
